Columns

Indexes

Grants

Dependencies

Details


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
SID NUMBER Yes null 1 null
OBJ VARCHAR2(20 BYTE) Yes null 2 null
ID VARCHAR2(100 BYTE) Yes null 3 null
TITLE VARCHAR2(100 BYTE) Yes null 4 null
LIAISON_TYPE VARCHAR2(4000 BYTE) Yes null 5 null
LIAISON_LEVEL VARCHAR2(4000 BYTE) Yes null 6 null
LIAISON_DATE DATE Yes null 7 null
NARRATIVE CLOB Yes null 8 null
CREATED_BY VARCHAR2(100 BYTE) Yes null 9 null
CREATED_ON DATE Yes null 10 null
LAST_MODIFIED_BY VARCHAR2(100 BYTE) Yes null 11 null
LAST_MODIFIED_ON DATE Yes null 12 null
OBJ_TYPE VARCHAR2(100 BYTE) Yes null 13 null
ANALYSIS_TYPE VARCHAR2(4000 BYTE) Yes null 14 null
INDEX_OWNER INDEX_NAME COLUMNS UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS COLUMN_EXPRESSION JOIN_INDEX




PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OBJECT_ID OWNER OBJECT_TYPE OBJECT_NAME STATUS TYPE_LINK



References


NAME VALUE
CREATED 18-OCT-24
LAST_DDL_TIME 07-FEB-25
OWNER QART
MVIEW_NAME MV_BEHAVE_SCI_FILES
CONTAINER_NAME MV_BEHAVE_SCI_FILES
QUERY select l.SID, l.OBJ, l.ID, l.TITLE, r.display LIAISON_TYPE, rl.display LIAISON_LEVEL, l.LIAISON_DATE, l.NARRATIVE, l.CREATED_BY, l.CREATED_ON, l.LAST_MODIFIED_BY, l.LAST_MODIFIED_ON, ot.display OBJ_TYPE, '' ANALYSIS_TYPE from acm.t_f_liaison l inner join acm.t_acm_obj o on l.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid left outer join acm.t_acm_reference r on l.liaison_type = r.ref_key left outer join acm.t_acm_reference rl on l.liaison_level = rl.ref_key union all select ba.sid, ba.obj, ba.id, ba.title, '' LIAISON_TYPE, '' LIAISON_LEVEL, null LIAISON_DATE, ba.narrative,  o.CREATED_BY, o.CREATED_ON, o.LAST_MODIFIED_BY, o.LAST_MODIFIED_ON, ot.display OBJ_TYPE, r.display analysis_type from acm.t_f_behavioral_analysis ba inner join acm.t_acm_obj o on ba.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid left outer join acm.t_acm_reference r on ba.analysis_type = r.ref_key union all select rnd.sid, rnd.obj, rnd.id, rnd.title, '' LIAISON_TYPE, '' LIAISON_LEVEL, null LIAISON_DATE, rnd.narrative,  o.CREATED_BY, o.CREATED_ON, o.LAST_MODIFIED_BY, o.LAST_MODIFIED_ON, ot.display OBJ_TYPE, '' ANALYSIS_TYPE from acm.t_f_rnd rnd inner join acm.t_acm_obj o on rnd.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid  union all select te.sid, te.obj, te.id, te.title, '' LIAISON_TYPE, '' LIAISON_LEVEL, null LIAISON_DATE, te.narrative,  o.CREATED_BY, o.CREATED_ON, o.LAST_MODIFIED_BY, o.LAST_MODIFIED_ON, ot.display OBJ_TYPE, '' ANALYSIS_TYPE from acm.t_f_train_edu te inner join acm.t_acm_obj o on te.obj = o.sid inner join acm.t_acm_obj_type ot on o.obj_type = ot.sid
QUERY_LEN 1633
UPDATABLE N
UPDATE_LOG null
MASTER_ROLLBACK_SEG null
MASTER_LINK null
REWRITE_ENABLED N
REWRITE_CAPABILITY TEXTMATCH
REFRESH_MODE DEMAND
REFRESH_METHOD FORCE
BUILD_MODE IMMEDIATE
FAST_REFRESHABLE NO
LAST_REFRESH_TYPE COMPLETE
LAST_REFRESH_DATE 07-FEB-25
LAST_REFRESH_END_TIME 07-FEB-25
STALENESS FRESH
AFTER_FAST_REFRESH NA
UNKNOWN_PREBUILT N
UNKNOWN_PLSQL_FUNC N
UNKNOWN_EXTERNAL_TABLE N
UNKNOWN_CONSIDER_FRESH N
UNKNOWN_IMPORT N
UNKNOWN_TRUSTED_FD N
COMPILE_STATE VALID
USE_NO_INDEX N
STALE_SINCE null
NUM_PCT_TABLES 0
NUM_FRESH_PCT_REGIONS null
NUM_STALE_PCT_REGIONS null
SEGMENT_CREATED YES
EVALUATION_EDITION null
UNUSABLE_BEFORE null
UNUSABLE_BEGINNING null
DEFAULT_COLLATION USING_NLS_COMP
ON_QUERY_COMPUTATION N
DUPLICATED N
SHARDED N